﻿CREATE TABLE [dbo].[usix.t_Upload] (
    [Customer #]                     FLOAT          NULL,
    [Name]                           NVARCHAR (255) NULL,
    [Address]                        NVARCHAR (255) NULL,
    [City]                           NVARCHAR (255) NULL,
    [St]                             NVARCHAR (255) NULL,
    [Zip Code]                       FLOAT          NULL,
    [Home Phone #]                   FLOAT          NULL,
    [Work Phone #]                   FLOAT          NULL,
    [Car Year]                       FLOAT          NULL,
    [Make]                           NVARCHAR (255) NULL,
    [Model]                          NVARCHAR (255) NULL,
    [Serial#]                        NVARCHAR (255) NULL,
    [Partial Payment]                FLOAT          NULL,
    [Tag#]                           FLOAT          NULL,
    [Color]                          FLOAT          NULL,
    [Simple/Add-On]                  NVARCHAR (255) NULL,
    [Open Date]                      DATETIME       NULL,
    [Pymnt Schedule]                 NVARCHAR (255) NULL,
    [# of Payments]                  FLOAT          NULL,
    [Payment Amount]                 FLOAT          NULL,
    [Total Payments]                 FLOAT          NULL,
    [Irregular Balance]              FLOAT          NULL,
    [1st# Payment Date]              DATETIME       NULL,
    [Last Payment Date]              DATETIME       NULL,
    [Next Payment Date]              DATETIME       NULL,
    [# Pmts Remaining]               FLOAT          NULL,
    [Balance Remaining]              FLOAT          NULL,
    [Tag Balance]                    FLOAT          NULL,
    [Sales Tax]                      FLOAT          NULL,
    [Total Sales Price]              FLOAT          NULL,
    [Finance Charges]                FLOAT          NULL,
    [Purchase Price]                 FLOAT          NULL,
    [Repairs]                        FLOAT          NULL,
    [Status Code]                    NVARCHAR (255) NULL,
    [Late Code]                      FLOAT          NULL,
    [Office Code]                    FLOAT          NULL,
    [Other Chgs Balance]             FLOAT          NULL,
    [Credit Life Prem]               FLOAT          NULL,
    [Credit Disb Prem]               FLOAT          NULL,
    [Stock#]                         FLOAT          NULL,
    [P#O#E#]                         NVARCHAR (255) NULL,
    [Loan#/Comments]                 NVARCHAR (255) NULL,
    [Primary SSN]                    FLOAT          NULL,
    [Perm# Office Code]              FLOAT          NULL,
    [Amt# Fin#/Disc# Amt]            FLOAT          NULL,
    [Interest Income]                FLOAT          NULL,
    [Earned Discount]                FLOAT          NULL,
    [Dealer Discount]                FLOAT          NULL,
    [Dealer Proceed]                 FLOAT          NULL,
    [Dealer Code]                    FLOAT          NULL,
    [Principal Balance]              FLOAT          NULL,
    [Interest Accrued]               FLOAT          NULL,
    [APR]                            FLOAT          NULL,
    [Mileage]                        FLOAT          NULL,
    [Collector Id#]                  FLOAT          NULL,
    [Warranty Prem]                  FLOAT          NULL,
    [Prop# Damage Prem]              FLOAT          NULL,
    [Type Paper]                     FLOAT          NULL,
    [Check#]                         FLOAT          NULL,
    [Check Date]                     NVARCHAR (255) NULL,
    [G/L Date]                       NVARCHAR (255) NULL,
    [Entry Clerk]                    FLOAT          NULL,
    [Entry Date]                     NVARCHAR (255) NULL,
    [Discount%]                      NVARCHAR (255) NULL,
    [NSF Balance]                    FLOAT          NULL,
    [Late Chg Bal]                   FLOAT          NULL,
    [Apply Late Fee]                 NVARCHAR (255) NULL,
    [V#S#I#]                         NVARCHAR (255) NULL,
    [Origination State Code]         NVARCHAR (255) NULL,
    [Buycode]                        FLOAT          NULL,
    [B#C#M#E#%]                      NVARCHAR (255) NULL,
    [Paid Retainage]                 NVARCHAR (255) NULL,
    [Date Paid]                      NVARCHAR (255) NULL,
    [Branch#]                        NVARCHAR (255) NULL,
    [Open Field#01]                  FLOAT          NULL,
    [Open Field#02]                  FLOAT          NULL,
    [Open Field#03]                  FLOAT          NULL,
    [Portfolio#]                     NVARCHAR (255) NULL,
    [Condition/Approved]             FLOAT          NULL,
    [Sales Code]                     FLOAT          NULL,
    [Sales Accounting Period]        FLOAT          NULL,
    [Sales Rep#]                     FLOAT          NULL,
    [Discount% Code]                 FLOAT          NULL,
    [Investor Client]                NVARCHAR (255) NULL,
    [Sales Date]                     NVARCHAR (255) NULL,
    [Car Class N/U?]                 NVARCHAR (255) NULL,
    [Type Car/Truck/Van?]            FLOAT          NULL,
    [Exchange of Collateral?]        NVARCHAR (255) NULL,
    [Recourse Y/N?]                  NVARCHAR (255) NULL,
    [Coupon Book Mailed Y/N?]        NVARCHAR (255) NULL,
    [Date Coupon Mailed]             NVARCHAR (255) NULL,
    [Coupon Mailed By (Init)]        NVARCHAR (255) NULL,
    [Collection Pmt Hold Y/N?]       NVARCHAR (255) NULL,
    [VSI Claim Pending Y/N?]         NVARCHAR (255) NULL,
    [VSI Claim Filed Y/N?]           NVARCHAR (255) NULL,
    [VSI Claim Must File Date]       NVARCHAR (255) NULL,
    [VSI Claim Date]                 NVARCHAR (255) NULL,
    [VSI Follow Up Date]             NVARCHAR (255) NULL,
    [VSI Check Received Y/N?]        NVARCHAR (255) NULL,
    [VSI Status O/C?]                FLOAT          NULL,
    [VSI Comments]                   FLOAT          NULL,
    [Bankruptcy Filed Y/N?]          NVARCHAR (255) NULL,
    [Collec# Calls prohib Y/N?]      NVARCHAR (255) NULL,
    [Bankruptcy Type 07/13?]         NVARCHAR (255) NULL,
    [Chap# 13 Claim Filed Y/N?]      NVARCHAR (255) NULL,
    [Bankruptcy Filing Date]         NVARCHAR (255) NULL,
    [Bankruptcy Hearing Date]        NVARCHAR (255) NULL,
    [Bankruptcy Jurisdiction]        NVARCHAR (255) NULL,
    [Bankruptcy Cause#]              NVARCHAR (255) NULL,
    [Debtor's Attorney]              NVARCHAR (255) NULL,
    [Trustee Name]                   NVARCHAR (255) NULL,
    [Reaffirmation Y/N?]             NVARCHAR (255) NULL,
    [Reaffirmation Date]             NVARCHAR (255) NULL,
    [Rescission Exp# Date]           NVARCHAR (255) NULL,
    [Bankruptcy Discharge Date]      NVARCHAR (255) NULL,
    [Bankruptcy Dismissal Date]      NVARCHAR (255) NULL,
    [Bankruptcy Follow Up Date]      NVARCHAR (255) NULL,
    [Bankruptcy Comments]            NVARCHAR (255) NULL,
    [Title Documents Rec# Date]      NVARCHAR (255) NULL,
    [Title Applied For Y/N?]         NVARCHAR (255) NULL,
    [Title Applied For (Init)]       NVARCHAR (255) NULL,
    [Title Application Date]         NVARCHAR (255) NULL,
    [Title Follow Up Date]           NVARCHAR (255) NULL,
    [Title Received Y/N?]            NVARCHAR (255) NULL,
    [Title Received Date]            NVARCHAR (255) NULL,
    [Title Lien Release Date]        NVARCHAR (255) NULL,
    [Second Lien Y/N?]               NVARCHAR (255) NULL,
    [Second Lien Date]               NVARCHAR (255) NULL,
    [Second Lien Holder]             NVARCHAR (255) NULL,
    [Second Lien Release Date]       NVARCHAR (255) NULL,
    [Title Sent To Lender Y/N?]      NVARCHAR (255) NULL,
    [Title Comments]                 NVARCHAR (255) NULL,
    [Out For Repossession Y/N?]      NVARCHAR (255) NULL,
    [Date Repo Ordered]              NVARCHAR (255) NULL,
    [Repo Follow Up Date]            NVARCHAR (255) NULL,
    [Repo Agent]                     NVARCHAR (255) NULL,
    [Purchase Order#]                NVARCHAR (255) NULL,
    [Authorized By (Init)]           NVARCHAR (255) NULL,
    [Vehicle Secured Y/N?]           NVARCHAR (255) NULL,
    [Date Repossessed]               NVARCHAR (255) NULL,
    [Vehicle Location]               NVARCHAR (255) NULL,
    [Vehicle Mileage]                NVARCHAR (255) NULL,
    [Dealer Buyback Y/N?]            NVARCHAR (255) NULL,
    [Estimated Damage]               NVARCHAR (255) NULL,
    [Repaired Y/N?]                  NVARCHAR (255) NULL,
    [Repair Cost]                    NVARCHAR (255) NULL,
    [Repo/Collection Expense]        NVARCHAR (255) NULL,
    [Repo Title Applied Y/N?]        NVARCHAR (255) NULL,
    [Repo Title Applic# Date]        NVARCHAR (255) NULL,
    [Redemption Date]                NVARCHAR (255) NULL,
    [Acceleration Date]              NVARCHAR (255) NULL,
    [Life/A&H Cancel Date]           NVARCHAR (255) NULL,
    [Warranty Cancel Date]           NVARCHAR (255) NULL,
    [Auction Date]                   NVARCHAR (255) NULL,
    [Auction Site]                   NVARCHAR (255) NULL,
    [Sale Date]                      NVARCHAR (255) NULL,
    [Black Book Value]               NVARCHAR (255) NULL,
    [Preferred Sale Amount]          NVARCHAR (255) NULL,
    [Bid Amount]                     NVARCHAR (255) NULL,
    [Bid Accepted Y/N?]              NVARCHAR (255) NULL,
    [Check Received Y/N?]            NVARCHAR (255) NULL,
    [Check Amount]                   NVARCHAR (255) NULL,
    [Check#1]                        NVARCHAR (255) NULL,
    [Check Date1]                    NVARCHAR (255) NULL,
    [Repo Comments]                  NVARCHAR (255) NULL,
    [File In/Out I/O?]               NVARCHAR (255) NULL,
    [File Out Date]                  NVARCHAR (255) NULL,
    [File Assigned To (Name)]        NVARCHAR (255) NULL,
    [File Clerk (Init)]              NVARCHAR (255) NULL,
    [Late Chg Balance]               NVARCHAR (255) NULL,
    [DOC Stamp]                      NVARCHAR (255) NULL,
    [Credit Code]                    NVARCHAR (255) NULL,
    [Close Out Code]                 NVARCHAR (255) NULL,
    [Open Field#04]                  NVARCHAR (255) NULL,
    [Open Field#05]                  NVARCHAR (255) NULL,
    [Open Field#06]                  NVARCHAR (255) NULL,
    [Open Field#07]                  NVARCHAR (255) NULL,
    [Open Field#08]                  NVARCHAR (255) NULL,
    [Open Field#09]                  NVARCHAR (255) NULL,
    [Open Field#10]                  NVARCHAR (255) NULL,
    [Open Field#11]                  NVARCHAR (255) NULL,
    [Open Field#12]                  NVARCHAR (255) NULL,
    [Date L/C]                       NVARCHAR (255) NULL,
    [Open Field#13]                  NVARCHAR (255) NULL,
    [Queing Hold Date]               NVARCHAR (255) NULL,
    [L/C Partial]                    NVARCHAR (255) NULL,
    [L/C Pmt#]                       NVARCHAR (255) NULL,
    [Down Payment]                   NVARCHAR (255) NULL,
    [Title Rcvd From Lender Y/N?]    NVARCHAR (255) NULL,
    [Date Title Rcvd From Lendor]    NVARCHAR (255) NULL,
    [Contract Rcvd From Lendor Y/N?] NVARCHAR (255) NULL,
    [Date Contract Rcvd From Lendor] NVARCHAR (255) NULL,
    [Request Title From Lendor Y/N?] NVARCHAR (255) NULL,
    [Date Requested]                 NVARCHAR (255) NULL,
    [Reason Requested]               NVARCHAR (255) NULL,
    [Requested By]                   NVARCHAR (255) NULL,
    [Due Date Modified Y/N?]         NVARCHAR (255) NULL,
    [Sale Discount]                  NVARCHAR (255) NULL,
    [Primary Date of Birth]          NVARCHAR (255) NULL,
    [Primary Driver License#]        NVARCHAR (255) NULL,
    [Joint Name]                     NVARCHAR (255) NULL,
    [Joint Address]                  NVARCHAR (255) NULL,
    [Joint City]                     NVARCHAR (255) NULL,
    [Joint State]                    NVARCHAR (255) NULL,
    [Joint Zipcode]                  NVARCHAR (255) NULL,
    [Joint SSN]                      NVARCHAR (255) NULL,
    [Joint Date of Birth]            NVARCHAR (255) NULL,
    [Joint H Phone#]                 NVARCHAR (255) NULL,
    [Joint W Phone#]                 NVARCHAR (255) NULL,
    [Joint Driver License#]          NVARCHAR (255) NULL,
    [Open Field#14]                  NVARCHAR (255) NULL,
    [Primary Email]                  NVARCHAR (255) NULL,
    [Primary Cell #]                 NVARCHAR (255) NULL,
    [Joint Email]                    NVARCHAR (255) NULL,
    [Joint Cell #]                   NVARCHAR (255) NULL,
    [Impound Fee Per Day]            NVARCHAR (255) NULL,
    [Impound Date]                   NVARCHAR (255) NULL,
    [Impound Pelease Date]           NVARCHAR (255) NULL,
    [Open Field#15]                  NVARCHAR (255) NULL,
    [Open Field#16]                  NVARCHAR (255) NULL,
    [Open Field#17]                  NVARCHAR (255) NULL,
    [Open Field#18]                  NVARCHAR (255) NULL,
    [Open Field#19]                  NVARCHAR (255) NULL,
    [Open Field#20]                  NVARCHAR (255) NULL,
    [Open Field#21]                  NVARCHAR (255) NULL,
    [L/UL]                           NVARCHAR (255) NULL
);

